SHOW FULL COLUMNS FROM `mtr_bus_route` [ RunTime:0.000426s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-599-I-0' LIMIT 1 [ RunTime:0.000221s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-599-I-0' LIMIT 1 [ RunTime:0.000203s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-599-O-0' LIMIT 1 [ RunTime:0.000216s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-599-O-0' LIMIT 1 [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `mtr_bus_stop` [ RunTime:0.000390s ]
SELECT `id`,`name` FROM `mtr_bus_stop` WHERE `id` IN ('RMB-19975','RMB-19976','RMB-19978','RMB-19979','RMB-19980','RMB-19981','RMB-19982','RMB-19983','RMB-19984','RMB-19985','RMB-19988','RMB-19990','RMB-19991') [ RunTime:0.000303s ]
SELECT `id`,`no`,`co`,`name`,`stop_list`,`orig`,`dest` FROM `mtr_bus_route` `r` WHERE `r`.`bound` = 'O' AND ( JSON_CONTAINS(stop_list, '"RMB-19975"') ) LIMIT 10 [ RunTime:0.041520s ]